﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='search_select_all' and s.name='Meta')
DROP PROCEDURE [Meta].search_select_all
GO
CREATE PROCEDURE [Meta].search_select_all 
AS
BEGIN
SELECT 	
	[Search].[id_reference] AS [PK],
	[Search].[display_name] AS [DisplayName],
	[Search].[item_type] AS [ItemType],
	[Search].[search_field] AS [SearchField]
FROM 
	[Meta].[Search] 
END